class CreateVehicles < ActiveRecord::Migration
  def change
    create_table :vehicles do |t|
      t.string :vehicle_no
      t.string :driver_name
      t.string :driver_phone
      t.string :vehicle_type
      t.integer :longitude
      t.integer :latitude
      t.string :groups
      t.references :motorcade
      t.string :destination
      t.string :bl_no
      t.datetime :require_arrive_time

      t.timestamps
    end
    add_index :vehicles, :motorcade_id
  end
end
